
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE ID = OBJECT_ID(N'Shop') and OBJECTPROPERTY(ID, N'IsUserTable') = 1) BEGIN

   -- Create Employee 1:N table
   CREATE TABLE [Shop] (
   	Id INT IDENTITY (1, 1) NOT NULL,
   	[Name] NVARCHAR(255) NOT NULL,
   	Host VARCHAR(255) NULL,
   	SQLInstance VARCHAR(50) NULL
   
      -- Create non-clustered primary key
   	CONSTRAINT [rpk_Shop] PRIMARY KEY NONCLUSTERED 
   	(
   		Id
   	)  ON [PRIMARY] ,
   ) ON [PRIMARY]

END








